﻿<%@ page import="bdSQL.SolicitacaoAction"%>
<%@ page import="bdSQL.Banco"%>
<%@ page import="bdSQL.DataUtils"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="base.Solicitacao"%>
<%@ page import="java.sql.ResultSet"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML lang="" xml:lang="" xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>SISTRANS - Sistemas de Transporte | SEDES</TITLE>
<META http-equiv=Content-Type content=text/html;charset=utf-8>
<SCRIPT 
src="../img/ploneScripts2522.js" 
type=text/javascript>
                </SCRIPT>

<SCRIPT type=text/javascript><!--  
/* - analytics.js - */
// http://www.agecom.ba.gov.br/portal_javascripts/analytics.js?original=1
document.write('<script src="http://www.google-analytics.com/urchin.js" type="text/JavaScript"><\/script>');
function callGoogleAnalytics(){_uacct="UA-328808-1";urchinTracker()}
registerPloneFunction(callGoogleAnalytics);

                     // --></SCRIPT>

<SCRIPT src="../img/scripts.js" 
type=text/javascript>
                </SCRIPT>

<SCRIPT src="../img/prototype.js" 
type=text/javascript>
                </SCRIPT>

<SCRIPT src="../img/ufo.js" 
type=text/javascript>
                </SCRIPT>

<SCRIPT src="../img/swfobject.js" 
type=text/javascript>
                </SCRIPT>

<SCRIPT 
src="../img/AC_RunActiveContent.js" 
type=text/javascript>
                </SCRIPT>
 
<style type="text/css" media="all">
			<!--
			@import url( http://www.agecom.ba.gov.br/portal_css/220i%20WWW/css/estilos.css );
			-->
		</style>

<script>
	function abreJanela(id){
		var width =500;
		var height =500;
		var left = ((screen.width)/2)-(600/2);
		var top = ((screen.height)/2)-(500/2);
		window.open("../geral/popupMunicipios.jsp?metodo=alterar&id="+id,'janela', 'width='+width+', height='+height+', top='+top+', left='+left+', scrollbars=yes, status=yes, toolbar=no, location=no, directories=no, menubar=no, resizable=no, fullscreen=no');	
	
	}
	</script>
<LINK href="http://www.agecom.ba.gov.br/favicon.ico" type=image/x-icon 
rel="shortcut icon"><!-- Disable IE6 image toolbar -->
<META http-equiv=imagetoolbar content=no>
<META content="MSHTML 6.00.6000.16525" name=GENERATOR>
</HEAD>
<BODY 
onload="MM_preloadImages('/images/mn_comunicacao_over.gif','/images/mn_conheca_over.gif','/images/mn_fale_over.gif')">
<TABLE cellSpacing=0 cellPadding=0 width=779 align=center bgColor=#ffffff 
border=0>
  <TBODY>
  <TR>
    <TD width=5><IMG height=98 
      src="../img/bg_sombra_01.jpg" 
      width=5></TD>
    <TD vAlign=center align=middle width=225><A 
      href="http://www.sedes.ba.gov.br/" name=topo><IMG height=88 
      src="../img/logo.gif" 
      width=157></A></TD>
    <TD width=545 
    background=../img/bg_banner.jpg align="center">
     </TD>
    <TD width=5><IMG height=98 
      src="../img/bg_sombra_02.jpg" 
      width=5></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=779 align=center border=0>
  <TBODY>
  <TR vAlign=top>
    <TD width=5><IMG height=550 
      src="../img/bg_sombra_03.jpg" 
      width=5></TD>
    <TD width=769 bgColor=#ffffff>
      <TABLE cellSpacing=0 cellPadding=0 width=769 border=0>
        <TBODY>
        <TR>
          <TD width=769 bgColor=#0078c0 height=2></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width=769 
      background=../img/menu_bg.jpg 
      border=0>
        <TBODY>
        <TR>
          <TD width=135><IMG height=24 src="../img/tit_sedes.gif" width=206></TD>
          <TD width=1><IMG height=15 
            src="../img/menu_divisao.gif" 
            width=1></TD>
          <TD width=52><A href="http://#"><IMG height=24 src="../img/bothome.gif" width=52></A></TD>
          <TD width=1><IMG height=15 
            src="../img/menu_divisao.gif" 
            width=1></TD>
          <TD width=10></TD>
		  <TD width=425 class="branco"> <%SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
											  out.println(sdf.format(DataUtils.dataAtual()));%> - <% out.println(session.getAttribute("nomeUsuario"));%></TD>
          <TD width=10></TD>
          <TD width=138>
            <FORM name=busca onSubmit="" action=/search method=post><INPUT 
            id=input_buscanosite 
            onclick="if (this.value == 'Busca') this.value='';" size=15 
            value=Busca name=SearchableText> &nbsp;<INPUT type=image height=15 
            width=12 
            src="../img/btn_ok.jpg" 
            align=absMiddle> </FORM></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width=769 border=0>
        <TBODY>
        <TR>
          <TD width=769 bgColor=#002271 height=2></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width=769 border=0>
        <TBODY>
        <TR vAlign=top>
          <TD width=130>
            <TABLE cellSpacing=0 cellPadding=0 width=130 bgColor=#0b7ac2 
            border=0>
              <TBODY>
              <TR>
                <TD width=130 height=10></TD></TR>
              <TR>
                <TD width=130><A 
                  href="http://#"><IMG id=ImageSolicV 
                  onmouseover="MM_swapImage('ImageSolicV','','../img/botsolicveic_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=37 
                  src="../img/botsolicveic.gif" 
                  width=130 border=0></A></TD></TR>
              <TR>
                <TD align=middle width=130><IMG height=1 
                  src="../img/menu_h_divisao.gif" 
                  width=112></TD></TR>
              <TR>
                <TD width=130><A 
                  href="http://#" 
                  target=_blank><IMG id=ImageVeic 
                  onmouseover="MM_swapImage('ImageVeic','','../img/botveic_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=24 
                  src="../img/botveic.gif" 
                  width=130 border=0></A></TD>
              </TR>
              <TR>
                <TD align=middle width=130><IMG height=1 
                  src="../img/menu_h_divisao.gif" 
                  width=112></TD></TR>
              <TR>
                <TD width=130><A 
                  href="http://#"><IMG id=ImageCond 
                  onmouseover="MM_swapImage('ImageCond','','../img/botcond_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=24 
                  src="../img/botcond.gif" 
                  width=130 border=0></A></TD>
              </TR>
              <TR>
                <TD align=middle width=130><IMG height=1 
                  src="../img/menu_h_divisao.gif" 
                  width=112></TD></TR>
              <TR>
                <TD width=130><A 
                  href="http://#"><IMG id=ImageRela 
                  onmouseover="MM_swapImage('ImageRela','','../img/botrela_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=24 
                  src="../img/botrela.gif" 
                  width=130 border=0></A></TD></TR>
              <TR>
                <TD align=middle width=130><IMG height=1 
                  src="../img/menu_h_divisao.gif" 
                  width=112></TD></TR></TBODY></TABLE>
            <TABLE cellSpacing=0 cellPadding=0 width=130 bgColor=#0871b9 
            border=0>
              <TBODY>
              <TR>
                <TD width=130 height=5 align="center"><a href="http://#"><img height=24 src="../img/botnovasolic.gif" width=130></a></TD>
              </TR>
              </TBODY></TABLE>
            </TD>
          <TD width=629>
            <TABLE cellSpacing=0 cellPadding=0 width=100% border=0>
              <TBODY>
              <TR>
                <TD width=629 height=12></TD></TR>
              <TR>
                <TD height=12><img src="../img/tit_solicfeitas.gif" width="469" height="25"><IMG id=ImageSolicPass 
                  onmouseover="MM_swapImage('ImageSolicPass','','../img/tit_solicpassadas_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=25 
                  src="../img/tit_solicpassadas.gif" 
                  width=160 border=0></TD>
              </TR>
              <TR>
                <TD height=12></TD>
              </TR>
              <TR>
                <TD height=12><img src="../img/tit_solicandamentolp.gif" width="549" height="25"><IMG id=ImageFiltrar 
                  onmouseover="MM_swapImage('ImageFiltrar','','../img/tit_filtrar_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=25 
                  src="../img/tit_filtrar.gif" 
                  width=81 border=0></TD>
              </TR>
              <TR>
                <TD height=12>
				<!-- ESTRUTURA DO WHILE -->
			<%
			ResultSet rs = null;
			SolicitacaoAction solicAction = new SolicitacaoAction();
			if (Banco.numLinhas(solicAction.verificaSolicitacoesEmAberto())==0){
				out.println("<td class='maintitle'> Não existem solicitações em aberto.</td>");
			}else{
				rs = solicAction.verificaSolicitacoesLocaisEPlantoesEmAberto();
				while(rs.next()){
			%>
				<table width="100%" border="0" bgcolor="#F8FAFA">
                  <tr>
                    <td width="30">
						<table width="100%" border="0" align="top">
						  <tr>
							<td class="destaques_assunto"><%=rs.getInt("idSolicitacao")%></td>
						  </tr>
						</table></td>
                    <td width="1"><img src="../img/menu_divisao.gif" width="1" height="60">                      </td>
                    <td width="600"><table width="100%" border="0" cellspacing="1" cellpadding="0">
                      <tr>
                        <td width="87%" class="manchete_titulo style1">AAA<%=rs.getString("passageiros")%> - <%=rs.getString("nomeSetor")%></td>
                        <td width="13%" align="center"><IMG id=ImageConfirmar
				  onmouseover="MM_swapImage('ImageConfirmar','','../img/botconfirmar_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=20 
                  src="../img/botconfirmar.gif" 
                  width=70 border=0></td>
                      </tr>
                      <tr>
                        <td class="azul"><%=rs.getString("itinerario")%></td>
                        <td class="azul">&nbsp;</td>
                      </tr>
                      <tr>
                        <td class="azul"><span class="style3">Saida:</span><%=sdf.format(rs.getDate("dataSaida"))%>/
																					 <%=rs.getString("horaSaida")%> <span class="style3">Retorno:</span><%=sdf.format(rs.getDate("dataRetorno"))%>/
			 					  <%=rs.getString("horaRetorno")%></td>
                        <td class="azul">&nbsp;</td>
                      </tr>
                      </table></td>
                  </tr>
                </table>
				<%}
				}%>
				<!-- FIM DO WHILE -->				</TD>
              </TR>
              <TR>
                <TD height=12><img src="../img/tit_solicandamentov.gif" width="549" height="25"><IMG id=ImageFiltrar2 
                  onmouseover="MM_swapImage('ImageFiltrar2','','../img/tit_filtrar_over.gif',1)" 
                  onmouseout=MM_swapImgRestore() height=25 
                  src="../img/tit_filtrar.gif" 
                  width=81 border=0></TD>
              </TR>
              <TR>
                <TD height=12>&nbsp;</TD>
              </TR>
              </TBODY></TABLE>
            <DIV>
            
          
            </DIV></TD></TR></TBODY></TABLE></TD>
    <TD width=5><IMG height=550 
      src="../img/bg_sombra_04.jpg" 
      width=5></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
  <TBODY>
  <TR>
    <TD width=760 colSpan=2 height=15></TD></TR>
  <TR>
    <TD width=760 bgColor=#0078c0 colSpan=2 height=2></TD></TR>
  <TR>
    <TD class=rodape width=539 
    background=../img/bg_rodape.gif 
    height=66>
      <P align=center><STRONG>SEDES - Secretaria de Desenvolvimento Social e Combate a Pobreza </STRONG><BR>
        sedes@sedes.ba.gov.br<BR>
        Coordenação de Modernização -- Atendimento SISTRANS: 3115 - 3841 </P>
      </TD>
    <TD width=240 height=66><IMG height=50 
      src="../img/logo_sedes.gif" 
      width=230></TD>
  </TR>
  <TR>
    <TD width=779 bgColor=#0078c0 colSpan=2 height=2></TD></TR></TBODY></TABLE></BODY></HTML>
